UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3+Ri7EqKfvBwb8lHUvGuB8Nqq3GM0BrFfpINyyYnmM0='
WHERE
key_id = '8d94d37a4366e698cdf5230724739ec1a02c08b50dfdaa5e2d10ba456729fc60'
AND (
token = '3+Ri7EqKfvBwb8lHUvGuB8Nqq3GM0BrFfpINyyYnmM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)