UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aEFPTG7J7VGAZE4/zE146b/nVKGFpK+XYREkLyod1HU='
WHERE
key_id = '2669a2b9690a9aca64a91cdcb6f8ae81155e7e625c7030f333bbccc3455718dc'
AND (
token = 'aEFPTG7J7VGAZE4/zE146b/nVKGFpK+XYREkLyod1HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)