UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KShN5lejdSufeeBnqZdcHQpo3fNKJXu0fSDhUFeTT0='
WHERE
key_id = 'd2ddc79a8eff5ddee54a7829125e414136520ae68a798cf9729bf46c9aa74afa'
AND (
token = '3KShN5lejdSufeeBnqZdcHQpo3fNKJXu0fSDhUFeTT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)