UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WMjo8waDrY3bEcvW8lD7luMerGaCiLMVLDHZ2zvVOo4='
WHERE
key_id = '97c641e11d3b5aeaebc81d50a9e8497ef03316b06c1feb5523b559094add2517'
AND (
token = 'WMjo8waDrY3bEcvW8lD7luMerGaCiLMVLDHZ2zvVOo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)