UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3LAU86uWgwmWBn6NUlWSaJR/OOzv3xw03fy+xcI60ok='
WHERE
key_id = '1873b9abebe94c0457e5c72d7024b3710dde18431e936b4451fd75cf79c757a2'
AND (
token = '3LAU86uWgwmWBn6NUlWSaJR/OOzv3xw03fy+xcI60ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)