UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPzasMj9+T0rrPxRGqqrIYT04MHqsHqIulZaAPaThAA='
WHERE
key_id = '1cc99112f314f2773722ffbf68423952e2d9b288eda37dd1c498ae2ae353a04f'
AND (
token = 'ZPzasMj9+T0rrPxRGqqrIYT04MHqsHqIulZaAPaThAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)