UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S/mEZjW13TdUdXz3CUnU0Tyi8js7qThAYL04JDvfz8g='
WHERE
key_id = '97164968f0199eb3aa48ae412221976db5ce72173e1656030600c873ac707c78'
AND (
token = 'S/mEZjW13TdUdXz3CUnU0Tyi8js7qThAYL04JDvfz8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)