UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgSegqQNCl5kyX7gMAPm+KpQ3oo8jb0jFlId7vyWVTQ='
WHERE
key_id = '9107a3e0e8f324cee514dda7da6f4e0e0683ad14adc23d52a5eb4bde8780ee26'
AND (
token = 'qgSegqQNCl5kyX7gMAPm+KpQ3oo8jb0jFlId7vyWVTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)