UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '399BqgPWYzIFJ9qDLewAxLuYfSsQ8pX1AZMwS059FvU='
WHERE
key_id = 'd5ff9d4881f4c16f2311faa4b7676155a19d2fd83a9779453731f3994b7298e0'
AND (
token = '399BqgPWYzIFJ9qDLewAxLuYfSsQ8pX1AZMwS059FvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)