UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xj/JYyVrr4B5GBcUvAYyymXAd8GqSNHbnI+s1lsVGD8='
WHERE
key_id = 'b2306911e268ee0b4ea5707cb9ddd77537d6d5c10f0c16a07e8a9f42da774f1f'
AND (
token = 'Xj/JYyVrr4B5GBcUvAYyymXAd8GqSNHbnI+s1lsVGD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)