UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ItLpRxd1pzW6FPjZGbiVFfi6FVMwBeiDq0g9WQSOYUU='
WHERE
key_id = '0bd22e6c7186c4729f67f10a6c5ee2b66787deed0472379767b6db91334174fb'
AND (
token = 'ItLpRxd1pzW6FPjZGbiVFfi6FVMwBeiDq0g9WQSOYUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)