UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pOyRMvDrTqKUFXenkCa3mmLpYYhnOOJPE41NL93iAU='
WHERE
key_id = '5cad386d74f8b2ba493dcf731462ff0fb2cef75797addfbe13426be022346ffd'
AND (
token = '8pOyRMvDrTqKUFXenkCa3mmLpYYhnOOJPE41NL93iAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)