UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hJjUjh4Iv0gHS9MV8fzl59677iPiPBhYri17aDeUUZY=' 
WHERE 
  key_id = 'fad9bbf76dcb5595954b78c589b7ea05487d78fab66ff916b3c7c229975007fd' 
  AND (
    token = 'hJjUjh4Iv0gHS9MV8fzl59677iPiPBhYri17aDeUUZY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033