UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBRzjCzZjUwtO/zuk5awzU5Dbd56y7JQCVFpOUI5KxE='
WHERE
key_id = 'ebfa4587ee78a77dfbc246eb5c1701c655ce6d58284f6d148d7fbbb2c6d29725'
AND (
token = 'QBRzjCzZjUwtO/zuk5awzU5Dbd56y7JQCVFpOUI5KxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)