UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZvZG6npggNNsglMm1nS+LpF4+wzkvGa+olWFmG9ZFf8='
WHERE
key_id = '1a023d3d6888f773adc383f32562936d0ae079d77126529fabb457f760d4a10d'
AND (
token = 'ZvZG6npggNNsglMm1nS+LpF4+wzkvGa+olWFmG9ZFf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)