UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGXQNqZ3ATfiQ85qxEVTrdW80ejvr9Ap6WHds4M1N4o='
WHERE
key_id = 'cf1eb550506ee7df234eb8dd87454d147b93f96132c9590ce8e530b3194540d5'
AND (
token = 'NGXQNqZ3ATfiQ85qxEVTrdW80ejvr9Ap6WHds4M1N4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)