UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fg6aNYLVtEtH5OWwliwExx31+XoVzfHjz+OcnH3hiW0='
WHERE
key_id = '2e61cb0a8fb1c2d9e4a9b5eb33e3ab48aee386d71e66ef3491f8cdafc008cae1'
AND (
token = 'fg6aNYLVtEtH5OWwliwExx31+XoVzfHjz+OcnH3hiW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)