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