UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cF2tYSfMeDgozvE07mhxm1iwaPC/5MnOTvUbn8QeBk='
WHERE
key_id = '789c765b700d7140493c93adb8d22b2a31a20304fac8ddec87c4bef683286e63'
AND (
token = '6cF2tYSfMeDgozvE07mhxm1iwaPC/5MnOTvUbn8QeBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)