UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hFfp4CQVSLSZXb+DpNsiZ5jRlSpTRB+JhGBobcC6mOs='
WHERE
key_id = '47df35be1af3e0bf9f6bfa3e548d69a1d1041a37bf966ffdae257921872ac1b8'
AND (
token = 'hFfp4CQVSLSZXb+DpNsiZ5jRlSpTRB+JhGBobcC6mOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)