UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfZPgoCo/3V9O+YjfpmVHgJcFwcjUcx2Gd3PC/e/YoA='
WHERE
key_id = '16a55aa3430b94f9cdd22c6f7e8e9c6a568a6d737efa20a92e6c3aba700fab75'
AND (
token = 'xfZPgoCo/3V9O+YjfpmVHgJcFwcjUcx2Gd3PC/e/YoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)