UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rJoqWGZ2UCr2yA2XwY0XpOdNPosbAzslZ2afMWh7zuw='
WHERE
key_id = '0ec4ee39541f6a0cb1baf23c075ed1492023a21be54a452577e22a7fcb5b07de'
AND (
token = 'rJoqWGZ2UCr2yA2XwY0XpOdNPosbAzslZ2afMWh7zuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)