UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNIWa0/hwJpeGjGIfj9Z+37x9gAuGG/AorBqTQ6xnnA='
WHERE
key_id = '2a9e5aff956eea8e87399e7f7c794f90c81adddc849db06f3ee311ca5a520588'
AND (
token = 'qNIWa0/hwJpeGjGIfj9Z+37x9gAuGG/AorBqTQ6xnnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)