UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0i5RAvGZpVgvS/MYggxHarSto3lVR3wuVHkrg/cdSGI='
WHERE
key_id = '6e8a776d9a66a7ee01da3d1e9fd9ccaaf1ea4c3990fcde12772112bef82858ce'
AND (
token = '0i5RAvGZpVgvS/MYggxHarSto3lVR3wuVHkrg/cdSGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)