UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g3SPjrHd9uFTrofoiUiEtqiKhMJ8ZEszCvrrx05HQ6w='
WHERE
key_id = '7effbd22b87e5e4b86d90557c8c31c048e639d4e91a017f2fde523d53d9b300d'
AND (
token = 'g3SPjrHd9uFTrofoiUiEtqiKhMJ8ZEszCvrrx05HQ6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)