UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4DjUBpGdg9dkhTiX82BJqIwUOidYTPvnFpe5cfGx1hw='
WHERE
key_id = 'b83e83d09e7caf385bb08fd9df343d9310bfbc2b668b9a86e4a85761c73de005'
AND (
token = '4DjUBpGdg9dkhTiX82BJqIwUOidYTPvnFpe5cfGx1hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)