UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BeQpGyZPiAMQGOuyWyqAr55V3CjtSd5dRdeBE3iN5Ec='
WHERE
key_id = 'f84d9aca2fd23bdee4c89786e26d47d80160a56b084b4ef460ba8c23d14ba9d0'
AND (
token = 'BeQpGyZPiAMQGOuyWyqAr55V3CjtSd5dRdeBE3iN5Ec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)