UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pifwT+8QoHAbmwR0CN1Vg7OlHMU4DYUM0zHi8VlTiKM='
WHERE
key_id = '1646cfb8c659b248899d80b8679c229735c9bfec692a4667bf9110b620cff8bb'
AND (
token = 'pifwT+8QoHAbmwR0CN1Vg7OlHMU4DYUM0zHi8VlTiKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)