UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zu0pkU+Q8h8LNTePuVYH1YjHiqBZzlgEhJZ2YBPS3KQ='
WHERE
key_id = 'f47f5ca3a432a2ecca4422bf6bdcee48f2979a19402e8b8e38d44e0c41bc0af1'
AND (
token = 'Zu0pkU+Q8h8LNTePuVYH1YjHiqBZzlgEhJZ2YBPS3KQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)