UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tz/4RF01AbGMm8ztF/WTqVZ5D9osb0EuVWJEa9Svktw='
WHERE
key_id = 'a3ffbb4d01bf4a984e7b2dbaf928b537a1c5a792365cc4545afd5daf307875d6'
AND (
token = 'tz/4RF01AbGMm8ztF/WTqVZ5D9osb0EuVWJEa9Svktw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)