UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FYxYl+h7epymuu7GJ4n6nId38H3fJCSSmcRlQYiOam4=' 
WHERE 
  key_id = '66f2a7e8ad52aee4ffc8a77fdbdf43d3c15271bcd92a0bc244de2a41d0a4c45b' 
  AND (
    token = 'FYxYl+h7epymuu7GJ4n6nId38H3fJCSSmcRlQYiOam4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033