UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DbQOMXG0EEnugUGD9oFWv6xQjre0fBv3g0/of+/dHU='
WHERE
key_id = '04dcad33f69e1da952b89296b15a85ec4e84c04fd6b6d18234e7f23bd913a947'
AND (
token = '9DbQOMXG0EEnugUGD9oFWv6xQjre0fBv3g0/of+/dHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)