UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tKhhN7wqh6a6gsPSuqGW8U021BU3zIujLMb+ONUWRMo='
WHERE
key_id = 'a22606a0b917323356ee95fc8fabcca7d81b885437a345fb93bc173a6fd92384'
AND (
token = 'tKhhN7wqh6a6gsPSuqGW8U021BU3zIujLMb+ONUWRMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)