UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cRomQvn44NMug/OKnF5cYQTS14fGNAlRVG2S8+Mx9Y='
WHERE
key_id = 'c65f506d47c54f976008044215e134590a2a28ea52399603d259787a7db3ea1a'
AND (
token = '7cRomQvn44NMug/OKnF5cYQTS14fGNAlRVG2S8+Mx9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)