UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TuT/NLPd75eLDrRnd+worJtxNEe/0u6UftC8ApKsw4='
WHERE
key_id = 'd9559b4cd69945a0b365b39a8078b1ad14cc4ab62f897acf4f60d7718bed0881'
AND (
token = '6TuT/NLPd75eLDrRnd+worJtxNEe/0u6UftC8ApKsw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)