UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZmmFx0YuhAxQqf0IklZcBelKU5WsNMU08CqsGa8Xcjg='
WHERE
key_id = '9f515835797ebdf3dbc03aba81874de89fdd6a8edd85fb369d69e1d9c48fa088'
AND (
token = 'ZmmFx0YuhAxQqf0IklZcBelKU5WsNMU08CqsGa8Xcjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)