UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8buO3YZV1UVhdqFcY9wuQHsGQ97AdRR2hxPO/LshtVc='
WHERE
key_id = 'fafa326dc1e7841e1aed07dbd6572d6c202245079958023295fbf66de198916e'
AND (
token = '8buO3YZV1UVhdqFcY9wuQHsGQ97AdRR2hxPO/LshtVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)