UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBvd9donQA4vnrD9rXn5bZXTw8t6+J2fHWjfUCzkZI4='
WHERE
key_id = '2919f8fbb2138dd678f4f89b8857e07626e11b47ba4d36e497dfdac44577b6ee'
AND (
token = 'OBvd9donQA4vnrD9rXn5bZXTw8t6+J2fHWjfUCzkZI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)