UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jEznA10r7wgcEAK7YX9obzckKi1JvD2EeAbNkWyocRg='
WHERE
key_id = '47c62dae9910fb7e6cc5971fbfd24bbd5f9c3c88125ee941f82a89cfbe94becf'
AND (
token = 'jEznA10r7wgcEAK7YX9obzckKi1JvD2EeAbNkWyocRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)