UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 's7n4/XN0IoGdEp3VEIZ4qkyIClZqVIFcSYjxYY5QqUI=' 
WHERE 
  key_id = '12ac449589a77e483c714fd2091527ce141a77b73db9de1841276a2ed1444710' 
  AND (
    token = 's7n4/XN0IoGdEp3VEIZ4qkyIClZqVIFcSYjxYY5QqUI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023