UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zx+SXRcZPA3v1kYXDH9rF0sV3LVCk44p8Wl9hQNWkMQ='
WHERE
key_id = '2e9b47a76481bad48d5c09c1a8ea3033648ea727172232ba3b3a9762e1281aec'
AND (
token = 'zx+SXRcZPA3v1kYXDH9rF0sV3LVCk44p8Wl9hQNWkMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)