UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xEcbFZAtckk0LZXITPcsdLpNaNxDi3aCjsIECCZkiqo='
WHERE
key_id = 'b7ae1951cab934eee1ec2059c2436b05cf7ddb70482100dd672a0e9db914ab36'
AND (
token = 'xEcbFZAtckk0LZXITPcsdLpNaNxDi3aCjsIECCZkiqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)