UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+bUCxw2eBjYtogCj7HWYPIclkLUzdcIdxixMm4NwOaI='
WHERE
key_id = '8d9c11aabdf0f19d98dd2df0d3913956c46cf83073ee7d7dfb9a14bdf75c04ed'
AND (
token = '+bUCxw2eBjYtogCj7HWYPIclkLUzdcIdxixMm4NwOaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)