UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '876Q1VfD8M8bcd5eMo4eozXKzDhlA6h1eQloyrkAjwY=' 
WHERE 
  key_id = 'ebb6914636bbef1af27dc87d1645fd53d72611ecf09cb3cf58e05d274222b077' 
  AND (
    token = '876Q1VfD8M8bcd5eMo4eozXKzDhlA6h1eQloyrkAjwY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023