UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1tOOJINddaKf4I2smkSHN/KAbB2c7y2tmx2e5QMxcI='
WHERE
key_id = 'a29846334191ab4b4168a6678d67679be76ecced22c6067ba265e3a3fb04f1d9'
AND (
token = 'z1tOOJINddaKf4I2smkSHN/KAbB2c7y2tmx2e5QMxcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)