UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmsL0tx2EYEIfx31RMMUjHJMmjjYpwjimStMguGf33c='
WHERE
key_id = '86c5edf9894f7bc63f2561ae8072087323b26d5ba1ffd5cea0591a4a8c50dce5'
AND (
token = 'tmsL0tx2EYEIfx31RMMUjHJMmjjYpwjimStMguGf33c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)